Skip to main content

Connect Data Connector

info

Thanks to our Data Connector, Mobility Work provides you with a set of database tables containing your network's maintenance data.

This data can be consulted via a Business Intelligence interface or - quite simply - with Microsoft Excel ( ODBC connection).

Aggregating and analyzing this data provides crucial information on equipment performance, maintenance trends and opportunities for improvement.

By combining this data with other relevant sources (MES, for example), it is possible to obtain a comprehensive overview that can be used to optimize maintenance programs and ensure ongoing equipment availability.

Our solution therefore offers added value to maintenance managers, enabling them to effectively manage and make optimum use of plant maintenance data.

Connexion​

info

Our OBDC connector is agnostic: you can connect it to different Business Intelligence systems, even Excel.

Connexion Power B.I.​

  • Connecting to PowerBI is very simple. You just need to fill in the following fields:
    • Database type: MySQL database
    • Server host: domain name provided by Mobility Work
    • Database name: provided by Mobility Work
    • Username: provided by Mobility Work
    • User password: provided by Mobility Work

alt text alt text alt text

warning

Since August 22, 2022, we've been experiencing a problem with connectors 8.0.17 and newer. If you're having trouble, try downloading an older version here (worked fine with 8.0.16)

Libre Office Connexion​

Create a new database connection

  • File > New > Database alt text
  • Choose to connect to an existing database
  • Choose the "MySQL/MariaDB" type alt text alt text alt text alt text alt text alt text alt text

Excel Connexion​

3 steps are required to connect Mobility Work data to Excel

  1. Add the MariaDB driver (the "technology" used by the Mobility Work database) to Windows.
  2. Connect our database to your Windows (add a data source in Windows)
  3. Connect your Excel to this data source.

Add the MariaDB connector to your Windows​

Download the connector : Download

alt text alt text

Once downloaded: install the connector

alt text alt text alt text alt text alt text

Add Mobility Work database as data source​

In your control panel, enter the term "ODBC" in the search bar alt text

Check that the connector is correctly installed alt text alt text

In the "User data source" tab, you can add the database connection. alt text alt text

The name you enter will help you distinguish the Mobilty Work database from your other (future) data sources: please, choose an explicit name. alt text

Enter the configuration parameters sent by Mobility Work alt text alt text alt text

Click on the "Test DSN" button to test the correct connection to the database. alt text

For the following screens, leave the default settings. alt text alt text alt text alt text

Your data source is added to your Windows. alt text

Using data in Excel​

alt text

Data menu>From other sources>From ODBC alt text

Select the Mobility Work data source. alt text

Enter the user name and password (supplied by Mobility Work) for database access. alt text

Your Excel is now connected to the Mobility Work database. alt text alt text

For example, you can add one of these tables to a tab in your Excel spreadsheet. alt text alt text

Close and load alt text

The data is present in your Excel spreadsheet. alt text

info

Use the "Refresh" button to "refresh" your Excel data.

This will fetch updated data from the database.